﻿INSERT  INTO dbo.Companies
        ( CompanyID ,
          Name ,
          Logo ,
          GUID 
        )
VALUES  ( 1 , 
          N'Amon MyX e-Consultores' ,
          N'AmonMyX.jpg' , 
          N'0FA66C32-BB02-4682-859A-51E0F72E63B8'     
        )
GO
INSERT INTO dbo.Masters
        ( MasterUsername ,
          Password ,
          Identification ,
          Name ,
          FirstName ,
          LastName ,
          CountryID ,
          StateID ,
          CityID ,
          Email ,
          Mobile ,
          Phone ,
          IsActive ,
          CreationDate
        )
VALUES  ( N'maxrodro' , -- MasterUsername - nvarchar(30)
          N'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3' , -- Password - nvarchar(100) = 123
          N'110940314' , -- Identification - nvarchar(16)
          N'Max' , -- Name - nvarchar(50)
          N'Rodriguez' , -- FirstName - nvarchar(50)
          N'Rojas' , -- LastName - nvarchar(50)
          0 , -- CountryID - int
          0 , -- StateID - int
          0 , -- CityID - int
          N'' , -- Email - nvarchar(50)
          N'' , -- Mobile - nvarchar(50)
          N'' , -- Phone - nvarchar(50)
          1 , -- IsActive - bit
          '2014-06-26 02:01:04'  -- CreationDate - datetime
        )

GO

--Roles
INSERT INTO dbo.MasterRoles
          ( MasterRoleID, 
		    Name )
  VALUES  ( 1, 
            N'Acceso a todas las pantallas')
GO
INSERT INTO dbo.MastersRolesByMaster
          ( MasterRoleID, 
		    MasterUsername )
  VALUES  ( 1,
            N'maxrodro'
            )

--Menu
GO
INSERT [dbo].[MenuTypes] ([MenuTypeId], [Name]) VALUES (1, N'Administrativo')
GO
INSERT [dbo].[MenuTypes] ([MenuTypeId], [Name]) VALUES (2, N'Mapa')
GO
INSERT [dbo].[MenuTypes] ([MenuTypeId], [Name]) VALUES (3, N'Dispositivos Móviles')
GO
INSERT [dbo].[TypeModules] ([TypeModuleID], [Name], [DirectoryPath]) VALUES (1, N'Módulo Manager', N'../../Manager/Pages/')
GO
INSERT [dbo].[TypeModules] ([TypeModuleID], [Name], [DirectoryPath]) VALUES (2, N'Módulo Map', N'../../Map/Pages/')
GO
INSERT [dbo].[TypeModules] ([TypeModuleID], [Name], [DirectoryPath]) VALUES (3, N'Módulo Manager - Módulo Map', N'../../Map/Pages/Google.aspx?Url=')
GO
INSERT [dbo].[TypeModules] ([TypeModuleID], [Name], [DirectoryPath]) VALUES (4, N'Módulo Manager - Módulo Map Directo', N'../../Map/Pages/')
GO
INSERT [dbo].[TypeModules] ([TypeModuleID], [Name], [DirectoryPath]) VALUES (5, N'Módulo Map - Módulo Manager Directo', N'../../Manager/Pages/')
GO

-- Menu Pages

INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (1, N'Compañias', NULL, N'Administración de compañias', N'', 1, 0, 0, N'company-building-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (2, N'Departamentos', NULL, N'Administración de departamentos', N'', 1, 1, 0, N'apartment-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (3, N'Administradores', NULL, N'Administración de administradores', N'', 1, 1, 0, N'User-Group-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (4, N'Usuarios', NULL, N'Administración de usuarios', N'', 1, 1, 0, N'User-Coat-Red-icon.png', 6, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (5, N'Dispositivos', NULL, N'Administración de dispositivos móviles', N'', 1, 1, 0, N'pda-icon.png', 7, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (6, N'Geocercas', NULL, N'Administración de geocercas', N'', 1, 1, 1, N'maps-pin-icon.png', 8, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (7, N'Clientes', NULL, N'Administración de clientes', N'', 1, 1, 0, N'Client-icon.png', 11, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (8, N'Notificaciones', NULL, N'Administración de notificaciones', N'', 1, 1, 0, N'Actions-view-pim-notes-icon.png', 12, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (9, N'Seguridad', NULL, N'Administración de seguridad', N'', 1, 1, 0, N'Status-security-high-icon.png', 13, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (10, N'Buses', NULL, N'Administración de buses', N'', 1, 1, 0, N'AWT-Bus.png', 14, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (11, N'Reportes', NULL, N'Impresión de reportes', N'', 1, 1, 0, N'sales-report-icon.png', 15, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (12, N'Administración Mapa', NULL, N'Administración del mapa', N'GoogleMap.aspx', 1, 1, 0, N'Google-Maps-icon.png', 16, 100, 100, NULL, NULL, 4, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (13, N'Salir del Sistema', NULL, N'Salir del sistema', N'LoginOut.aspx', 1, 1, 0, N'Log-Out-icon.png', 17, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (14, N'Compañia Manager', 1, N'Administrador de compañias', N'Companies.aspx', 1, 0, 0, N'company-building-icon.png', 1, 500, 300, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (15, N'Compañias por Master', 1, N'Administrador de compañias por master', N'CompaniesByMaster.aspx', 1, 0, 0, N'Company-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (16, N'Departementos Manager', 2, N'Administrador de departamentos', N'Departments.aspx', 1, 1, 0, N'apartment-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (17, N'Departamentos por administradores', 2, N'Administrador de departamentos por administrador', N'AdministratorsByDepartments.aspx', 1, 1, 0, N'apartment-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (18, N'Master', NULL, N'Administrador de master del sistema', N'', 1, 0, 0, N'User-Executive-Green-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (19, N'Master Manager', 18, N'Administrador de master del sistema', N'Masters.aspx', 1, 0, 0, N'User-Executive-Green-icon.png', 0, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (20, N'Administadores Manager', 3, N'Administrador de administradores', N'Administrators.aspx', 1, 1, 0, N'User-Administrator-Blue-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (21, N'Grupos de Usuarios', 4, N'Administrador de grupos de usuarios', N'UsersGroups.aspx', 1, 1, 0, N'User-Group-Blue-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (22, N'Grupos de Usuarios por Administradores', 4, N'Administrador de grupos de usuarios', N'UsersGroupsByAdminUsername.aspx', 1, 1, 0, N'User-Group-Blue-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (23, N'Consulta de usuarios', 4, N'Consulta de usuarios', N'Users.aspx', 1, 1, 0, N'User-Coat-Red-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (24, N'Grupos de dispositivos', 5, N'Administrador de grupos de dispositivos móviles', N'GPSGroups.aspx', 1, 1, 0, N'pda-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (25, N'Dispositivos  Manager', 5, N'Administrador de dispositivos móviles del sistema', N'GPSStock.aspx', 1, 0, 0, N'pda-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (26, N'Dispositivos por Grupos', 5, N'Administrador de dispositivos móviles por grupos', N'GPSGroupsByGPSStock.aspx', 1, 1, 0, N'pda-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (27, N'Grupos de dispositivos por Usuarios', 5, N'Administrador de dispositivos móviles por usuarios', N'UsersByGPSGroups.aspx', 1, 1, 0, N'pda-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (28, N'Asociar GPS al Usuario', 5, N'Administrador de dispositivos móviles por usuarios', N'UsersByGPSStocks.aspx', 1, 1, 0, N'pda-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (29, N'Modelos de GPS', 5, N'Administrador de modelos dispositivos móviles', N'GPSModels.aspx', 1, 0, 0, N'question-type-multiple-correct-icon.png', 6, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (30, N'Tipos de GPS', 5, N'Administrador de tipos de dispositivos móviles', N'GPSTypes.aspx', 1, 0, 0, N'question-type-one-correct-icon.png', 7, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (31, N'Comandos GPS', 5, N'Administrador de comandos SMS', N'GPSCommands.aspx', 1, 0, 0, N'Win-Command-Prompt-icon.png', 8, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (32, N'Geocerca Manager', 6, N'Administrador de geocercas', N'GoogleMap.aspx', 1, 1, 0, N'maps-icon-simple.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (33, N'Grupos de Clientes', 7, N'Administrador de grupos de clientes', N'ClientsGroups.aspx', 1, 1, 0, N'User-Group-Blue-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (34, N'Clientes Manager', 7, N'Administrador de clientes', N'Clients.aspx', 1, 1, 0, N'Client-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (35, N'Proceso de visita por cliente', 7, N'Proceso de visitas por cada cliente', N'TrackDataResumenByClients.aspx', 1, 1, 0, N'Client-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (36, N'Proceso de visitas en tiempo real', 7, N'Proceso de visitas del cliente en tiempo real', N'ClientsRealTime.aspx', 1, 1, 0, N'Client-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (37, N'Gráfico lineal de clientes', 7, N'Gráfico lineal de ruta por cliente', N'LinealViewInfo.aspx', 1, 1, 0, N'Client-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (38, N'Notificaciones Manager', 8, N'Administrador de notificaciones', N'Notifications.aspx', 1, 1, 0, N'Actions-view-pim-notes-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (39, N'Notifiaciones por GPS', 8, N'Administrador de notificaciones por dispositivos móviles', N'NotificacionsByGPS.aspx', 1, 1, 0, N'email-alert-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (40, N'Notificaciones en tiempo real', 8, N'Proceso de notificaciones en tiempo real', N'NotificationsRealTime.aspx', 1, 1, 0, N'Actions-view-pim-notes-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (41, N'Roles de Master', 9, N'Administrador de roles de master', N'MenuByMasterRoles.aspx', 1, 0, 0, N'Master-Status-security-high-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (42, N'Roles de Administrador', 9, N'Administrador de roles por administrador', N'MenuByAdministratorRoles.aspx', 1, 0, 0, N'Admin-Status-security-high-icon.png', 7, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (43, N'Roles de Usuario', 9, N'Administrador de roles de usuario', N'MenuByUserRoles.aspx', 1, 1, 0, N'User-Status-security-high-icon.png', 10, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (44, N'Asignación de roles master', 9, N'Asignación de roles master', N'MastersRolesByMaster.aspx', 1, 0, 0, N'System-Security-Question-Red-icon.png', 6, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (45, N'Asignación de roles administrador', 9, N'Asignación de roles administrador', N'AdministratorsRolesByAdministrator.aspx', 1, 1, 0, N'System-Security-Question-Blue-icon.png', 9, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (46, N'Asignación de roles usuario', 9, N'Asignación de roles usuario', N'UserRolesByUsers.aspx', 1, 1, 0, N'System-Security-Question-Pink-icon.png', 11, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (47, N'Administrador del menu Manager', 9, N'Administrador del menu manager del sistema', N'MenuManager.aspx', 1, 0, 0, N'System-Security-Question-Pink-icon.png', 1, 1300, 640, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (48, N'Choferes', 10, N'Administrador de choferes de buses', N'Drivers.aspx', 1, 1, 0, N'bus.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (49, N'Rutas', 10, N'Administrador de rutas de cada linea de buses', N'BusRoutes.aspx', 1, 1, 0, N'bus.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (50, N'IOVT Tiempo real', 10, N'Proceso de datos en tiempo real', N'VPCRealTime.aspx', 1, 1, 0, N'bus.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (51, N'IOVT Resumen por rutas', 10, N'Proceso de resumen por rutas', N'VPCResumenByBusRoutes.aspx', 1, 1, 0, N'bus.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (52, N'IOVT Resumen por paradas', 10, N'Proceso de resumen por paradas', N'VPCResumenByBusStops.aspx', 1, 1, 0, N'bus.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (53, N'IOVT Control de tarjetas', 10, N'Administrador de tarjetas por chofer', N'VPCControl.aspx', 1, 1, 0, N'bus.png', 6, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (54, N'IOVT Resumen por ruta', 11, N'Reporte resumen por ruta', N'VPCResumenByBusRoutesReports.aspx', 1, 1, 0, N'bus.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (55, N'IOVT Resumen de paradas', 11, N'Reporte de resumen de paradas', N'VPCResumenByBusStopsReports.aspx', 1, 1, 0, N'bus.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (56, N'Alertas por agentes', 11, N'Reporte de alertas por agente', N'NotiTopAlertByAgentsReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (57, N'Tiempos de visita a clientes por agente', 11, N'Reporte de tiempo de visitas a clientes', N'AgentsTimeByClientsReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (58, N'Tiempos por kilometro por agentes', 11, N'Reporte de tiempo por kilometros por agente', N'AgentsTimeByKmReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (59, N'Notificaciones generadas', 11, N'Reporte de notificaciones', N'NotificationsReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 6, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (60, N'Nofificaciones por geocercas', 11, N'Reporte de notificaciones por geocerca', N'NotificationsByGeoFencesReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 7, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (61, N'Resumen de alertas', 11, N'Resporte de resumen de alertas', N'NotificationsByNotiIDReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 8, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (62, N'Tiempos por agente por ruta', 11, N'Reporte de tiempos por agente por ruta', N'AgentTimeReports.aspx', 1, 1, 0, N'custom-reports-icon.png', 9, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (63, N'Cuenta', NULL, N'Administración de la cuenta', N'', 1, 1, 1, N'user.png', 1, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (64, N'Información Personal', 63, N'Información Personal', N'Account.aspx', 1, 1, 1, N'user.png', 1, 330, 500, 70, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (65, N'Dispositivos', NULL, N'Administración de dispositivos móviles', N'', 1, 1, 1, N'pda-icon.png', 2, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (66, N'Administración de Dispositivos', 65, N'Administración de dispositivos móviles', N'GPSManager.aspx', 1, 1, 1, N'pda-icon.png', 1, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (67, N'Lista de Dispositivos', 65, N'Lista de todos los dispositivos móviles asociados', N'GPSImei.aspx', 1, 1, 1, N'question-type-multiple-correct-icon.png', 2, 250, 600, 0, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (68, N'Rutas', NULL, N'Administración de rutas', N'', 1, 1, 1, N'app-map-icon.png', 3, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (69, N'Visualizar una ruta', 68, N'Reproduccir una ruta de un dispositivos móviles', N'Routes.aspx', 1, 1, 1, N'Google-Maps-icon.png', 1, 920, 340, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (70, N'Generar ruta de un agente', 68, N'Generación de rutas para agentes', N'RoutesManager.aspx', 1, 1, 0, N'Maps-icon.png', 2, 535, 575, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (71, N'Clientes', NULL, N'Administración de clientes', N'', 1, 1, 0, N'Client-icon.png', 4, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (72, N'Administrar clientes', 71, N'Administración de clientes', N'ClientManager.aspx', 1, 1, 0, N'User-Group-Blue-icon.png', 1, 975, 350, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (73, N'Visualizar clientes por ruta', 71, N'Visualizar clientes por rutas', N'ClientsRouteHistory.aspx', 1, 1, 0, N'User-Group-Blue-icon.png', 2, 1250, 370, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (74, N'Geocercas', NULL, N'Administración de geocercas', N'', 1, 1, 1, N'maps-pin-icon.png', 5, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (75, N'Administración geocercas', 74, N'Administración de geocercas', N'GeoFences.aspx', 1, 1, 1, N'maps-icon-simple.png', 1, 675, 300, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (76, N'Notificaciones', NULL, N'Administración de notificaciones', N'', 1, 1, 1, N'notes-book-icon.png', 6, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (77, N'Administrar notificaciones', 76, N'Administración de notificaciones', N'NotificationManager.aspx', 1, 1, 0, N'notes-folder-icon.png', 1, 400, 600, 0, 40, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (78, N'Notificaciones del día', 76, N'Visualizar notificaciones del día', N'NotificationHistoryByToday.aspx', 1, 1, 1, N'Notes-icon.png', 2, 675, 290, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (79, N'Notificaciones por fecha', 76, N'Reporte de notificaciones por fecha', N'NotificationHistoryByDates.aspx', 1, 1, 1, N'notepad-icon.png', 3, 685, 365, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (80, N'Buses', NULL, N'Administración de buses', N'', 1, 1, 0, N'AWT-Bus.png', 7, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (81, N'Registro de rutas', 80, N'Registro de rutas', N'BusRoutesManager.aspx', 1, 1, 0, N'Map-16.png', 1, 730, 315, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (82, N'Registro de paradas por ruta', 80, N'Registro de paradas por ruta', N'BusStopsManager.aspx', 1, 1, 0, N'Bus-Stop.png', 2, 930, 320, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (83, N'Visualización de paradas por ruta', 80, N'Reporte de paradas por ruta', N'BusStopsRouteHistory.aspx', 1, 1, 0, N'Bus-Stop.png', 3, 1250, 370, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (84, N'Visualizador de multiples rutas', 80, N'Visualizador de multiples rutas', N'BusStopsShowMultiplePages.aspx', 1, 1, 0, N'Bus-Stop.png', 4, 700, 215, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (85, N'Modo Master', NULL, N'Herramientas de uso de masters', N'', 1, 0, 0, N'Apps-gnome-window-manager-icon.png', 9, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (86, N'Genera Script de Markers', 85, N'Genera script de insert de markers', N'GenerateScripts.aspx', 1, 0, 0, N'Apps-gnome-window-manager-icon.png', 1, 1250, 170, 20, 50, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (87, N'Regresar al módulo administrativo', NULL, N'Regresar al módulo administrativo', N'WebDesktop.aspx', 1, 1, 0, N'Apps-gnome-window-manager-icon.png', 10, 100, 100, NULL, NULL, 5, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (91, N'Administrador del menu Map', 9, N'Administrador del menu map del sistema', N'MenuMap.aspx', 1, 0, 0, N'User-System-Security-Question-icon.png', 3, 1300, 640, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (92, N'Asignación de menus por Compañía', 9, N'Asigna los menus permitidos por compañía', N'CompaniesByMenu.aspx', 1, 0, 0, N'Admin-System-Security-Question-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (93, N'Asignación de Roles Administrativos por Compañía', 9, N'Asignación de Roles Administrativos por Compañía', N'CompaniesByAdministratorsRoles.aspx', 1, 0, 0, N'Admin-Status-security-high-icon.png', 8, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (94, N'Productos', NULL, N'Registro de Productos', N'', 1, 1, 0, N'notes-book-icon.png', 9, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (95, N'Consulta Productos', 94, N'Registro de Productos', N'Stocks.aspx', 1, 1, 0, N'notes-book-icon.png', 3, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (96, N'Ordenes', NULL, N'Administración de Ordenes', N'', 1, 1, 0, N'notepad-icon.png', 10, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (97, N'Consulta de Ordenes', 96, N'Permite Consultar Ordenes', N'Orders.aspx', 1, 1, 0, N'notepad-icon.png', 14, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (98, N'Mapas', NULL, N'Visualización de Mapas', N'', 1, 1, 1, N'Maps-icon.png', 8, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (99, N'Google Map', 98, N'Mapa de Google', N'GoogleMap.aspx', 1, 1, 1, N'Maps-icon.png', 8, 100, 100, NULL, NULL, 4, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (100, N'Open Street Map', 98, N'Mapa Open Source', N'OpenStreetMap.aspx', 1, 1, 1, N'Maps-icon.png', 8, 100, 100, NULL, NULL, 4, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (101, N'Gráfico lineal de clientes por catálogo', 7, N'Gráfico lineal del catalogo', N'CustomLinealViewCatalogo.aspx', 1, 1, 0, N'sales-report-icon.png', 14, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (102, N'Cuenta', NULL, N'Cuenta Manager', N'', 1, 1, 0, N'user.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (103, N'Información Personal', 102, N'Información Personal', N'Account.aspx', 1, 1, 0, N'user.png', 15, 350, 500, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (104, N'Cambio de contraseña', 102, N'Cambio de contraseña', N'ChangePassword.aspx', 1, 1, 0, N'Apps-preferences-system-login-icon.png', 15, 600, 350, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (105, N'Cambiar Contraseña', 63, N'Cambiar Contraseña', N'ChangePassword.aspx', 0, 0, 1, N'Apps-preferences-system-login-icon.png', 2, 600, 500, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (106, N'Salir del Sistema', NULL, N'Salir del Sistema', N'LoginOut.aspx', 1, 1, 1, N'Log-Out-icon.png', 11, NULL, NULL, NULL, NULL, 2, 2)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (107, N'Servicios de Windows', NULL, N'Visualiza los log de los servicios de windows en ejecución', N'WindowsServiceLog.aspx', 1, 0, 0, N'Apps-utilities-log-viewer-icon.png', 15, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (108, N'Administración de Clientes', NULL, N'Permite administrar clientes', N'5', 0, 0, 1, N'pda-icon.png', 1, NULL, NULL, NULL, NULL, 1, 3)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (109, N'Administración de las aplicaciones móviles', 9, N'Administración de las aplicaciones móviles del sistema', N'MenuMobile.aspx', 1, 1, 0, N'pda-icon.png', 2, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (110, N'Catálogo', NULL, N'Permite administrar clientes', N'2', 0, 0, 1, N'pda/icon.png', 3, NULL, NULL, NULL, NULL, 1, 3)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (111, N'Categorias', 94, N'Categorías de Productos', N'StockCategories.aspx', 1, 1, 0, N'sign-up-icon.png', 1, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (112, N'Productos por Categoría', 94, N'Registro de Productos por Categoría', N'StockByCategories.aspx', 1, 1, 0, N'sign-up-icon.png', 2, 1300, 640, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (113, N'Tipo de Archivos', 94, N'Tipo de archivos', N'StockFileTypeOfFile.aspx', 1, 1, 0, N'address-book-icon.png', 6, 500, 500, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (114, N'Archivos de empresa', 94, N'Archivos de empresa', N'StockFile.aspx', 1, 1, 0, N'document-add-icon.png', 4, NULL, NULL, NULL, NULL, 1, 1)
GO
INSERT [dbo].[Menu] ([MenuID], [Name], [Parent], [ToolTip], [Page], [IsVisibleMaster], [IsVisibleAdministrator], [IsVisibleUser], [ImageUrl], [BySequence], [Width], [Heigth], [PositionX], [PositionY], [TypeModuleId], [MenuTypeId]) VALUES (115, N'Asociar archivos con usuarios', 94, N'Asociar archivos con usuarios', N'StockFileByUsername.aspx', 1, 1, 0, N'User-Preppy-Blue-icon.png', 5, NULL, NULL, NULL, NULL, 1, 1)
GO

--Menu by Role

INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 1)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 2)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 3)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 4)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 5)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 6)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 7)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 8)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 9)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 11)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 12)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 13)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 14)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 15)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 16)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 17)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 18)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 19)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 20)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 21)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 22)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 23)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 24)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 25)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 26)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 27)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 28)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 29)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 30)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 31)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 32)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 33)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 34)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 35)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 36)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 37)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 38)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 39)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 40)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 41)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 42)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 43)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 44)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 45)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 46)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 47)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 48)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 49)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 50)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 51)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 52)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 53)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 56)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 57)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 58)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 59)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 60)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 61)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 62)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 63)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 64)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 65)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 66)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 67)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 68)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 69)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 70)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 71)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 72)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 73)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 74)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 75)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 76)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 77)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 78)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 79)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 80)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 81)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 82)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 83)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 84)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 85)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 86)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 87)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 91)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 92)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 93)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 94)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 95)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 98)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 99)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 100)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 102)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 103)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 104)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 106)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 107)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 109)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 111)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 112)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 113)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 114)
GO
INSERT [dbo].[MenuByMasterRoles] ([MasterRoleID], [MenuID]) VALUES (1, 115)
GO


--GPS
INSERT [dbo].[GPSModels] ([GPSModelID], [Name], [Port]) VALUES (1, N'Falcon Android', 8000)
GO
INSERT [dbo].[GPSModels] ([GPSModelID], [Name], [Port]) VALUES (2, N'Falcon Windows Mobile', 8001)
GO
INSERT [dbo].[GPSModels] ([GPSModelID], [Name], [Port]) VALUES (3, N'TK102', 8002)
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (1,'Vehículo','RedCar.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (2,'Taxi','YellowCar.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (3,'Bombero','FireTruck.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (4,'Bus','SchoolBus.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (5,'Ambulancia','Truck.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (6,'Hand Held','HandHeld.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (7,'Perro','dog-icon.png')
GO
INSERT INTO dbo.GPSType ( GPSTypeID, Name, Image ) VALUES  (8,'Trailer','Lorry.png')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (1, 3, 1, N'begin123456')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (2, 3, 2, N'apn123456{SPACE}{APN}')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (3, 3, 3, N'up123456{SPACE}{USERNAME}{SPACE}{PASSWORD}')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (4, 3, 4, N'adminip123456{SPACE}{IP}{SPACE}{PORT}')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (5, 3, 5, N't030s***n123456')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (6, 3, 6, N'tracker123456')
GO
INSERT [dbo].[GPSCommands] ([GPSCommandID], [GPSModelID], [OrderCommand], [CommandText]) VALUES (7, 3, 7, N'gprs123456')


--Catalogo
Insert Into Status Values('CAL','Calculando')
GO
Insert Into Status Values('ELI','Eliminado')
GO
Insert Into Status Values('ENF','Envío Finalizado')
GO
Insert Into Status Values('ERR','Error')
GO
Insert Into Status Values('FIN','Finalizado')
GO
Insert Into Status Values('PEE','Pendiente Envío')
GO
Insert Into Status Values('PEN','Pendiente')
GO
Insert Into Status Values('PRO','Proceso')
GO
Insert Into Status Values('SYN','Sincronizando')